package cn.com.surker.weight.dao;

import cn.com.surker.weight.entity.WeightInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 过磅完成信息表 Mapper 接口
 * </p>
 *
 * @author admin
 * @since 2024-11-07
 */
public interface WeightInfoDao extends BaseMapper<WeightInfo> {

    /**
     * 查询驾驶员电子磅单合计
     * @param phone
     * @param startTime
     * @param endTime
     * @param searchVal
     * @return
     */
    WeightInfo findTotalSum(String phone, String startTime, String endTime, String searchVal);

    /**
     * 统计车辆运输台账
     * @param phone
     * @param startTime
     * @param endTime
     * @param searchVal
     * @return
     */
    List<Map<String, Object>> findTranSportSum(String phone, String startTime, String endTime, String searchVal);

    /**
     * 查询订单详情
     * @param openid
     * @param code
     * @param phone
     * @return
     */
    WeightInfo findByOrder(String openid, String code, String phone);

}
